UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sj/RKWxrUdFV4kyqEO01Oa/4SnPHsGr8UUnHyhm9eVw='
WHERE
key_id = '1c7f15d26c57be5b7516ee62157909865959e6fac74854d5048c97716ae2eee1'
AND (
token = 'Sj/RKWxrUdFV4kyqEO01Oa/4SnPHsGr8UUnHyhm9eVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)