UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qR6p5qfBNSHkJQt7lzCjejanidVKsRGvYLLY1j/EGho='
WHERE
key_id = '9ca92fc23e2183cf03263a36583d1adf84de540cbf0d45774c9881573e891c1d'
AND (
token = 'qR6p5qfBNSHkJQt7lzCjejanidVKsRGvYLLY1j/EGho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)