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