UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ldfD9eE6pRhPrsbQQArkClGFatrAJU1ohf761qQTmw='
WHERE
key_id = '78b58df91cf674ea704dba86537209c9ef0133905292f23a6cc5a77c3ad3d5f5'
AND (
token = '6ldfD9eE6pRhPrsbQQArkClGFatrAJU1ohf761qQTmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)