UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Z8dG48u5ZT/+KDM3qaMpYaoCARah5geoIUIL3efQao='
WHERE
key_id = 'aee9ce22225b9b4511dcadf9484affe4443890421b793413fb91ecf015000ae7'
AND (
token = '3Z8dG48u5ZT/+KDM3qaMpYaoCARah5geoIUIL3efQao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)