UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0hzNJsBnJcgOi+lc9EB9WCHDQE1evLqhnFCW7fHytI='
WHERE
key_id = 'd8fd1db00d0886855cd2d74d59bc4b8086a1f45a68974c19f55f913f8a1edae6'
AND (
token = '/0hzNJsBnJcgOi+lc9EB9WCHDQE1evLqhnFCW7fHytI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)