UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iO0HEP7YPkk593jxlVALMPuOOTwmoDmX7NpdB67iGvI='
WHERE
key_id = 'ae070522487e0fda1d059a8bc66c45bc9f67273bc5c5d99b84cf11040bf2696f'
AND (
token = 'iO0HEP7YPkk593jxlVALMPuOOTwmoDmX7NpdB67iGvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)