UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b/M1jjtenE4jpAoDunIblnspvgPwvS0W1EK0BirslKE='
WHERE
key_id = '836311f23dd0aa5974ece1ffea8e717f3b4de347c30e94a90d9d25b04024b93d'
AND (
token = 'b/M1jjtenE4jpAoDunIblnspvgPwvS0W1EK0BirslKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)