UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7M6b16GfmEsJH34jCj/n/m3ibJhhc2ap+8GZRMpNuYc='
WHERE
key_id = '49398fd1634b803690e2fe901f0535933a5d99485a4bf848f2f9203b8be697ae'
AND (
token = '7M6b16GfmEsJH34jCj/n/m3ibJhhc2ap+8GZRMpNuYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)