UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsJSWQxnlLomwww+Stk3cJAZSuZbpLxVS7o9mvdeKpA='
WHERE
key_id = '8c561a0b9d2101c8fa640982d71f84cbc0758bd2ae4a0951214efcc515eab3ed'
AND (
token = 'ZsJSWQxnlLomwww+Stk3cJAZSuZbpLxVS7o9mvdeKpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)