UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4RKv40i/uYEbwl4rJkvOsV0agES80GSRa+0+wIXCKVc='
WHERE
key_id = '0b42d59894f3121d34042f9438f2b81a1875159bf3155931e32e21c362b5ed46'
AND (
token = '4RKv40i/uYEbwl4rJkvOsV0agES80GSRa+0+wIXCKVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)