UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xMhNZyUjq7azKY0WnZ6zYI0wnBGTLCIYErS4l+XCRe0='
WHERE
key_id = '3978873628fced64127a65e9a7e7a6e2400c8e9bfd31ebe3e50f59bdaa1bb301'
AND (
token = 'xMhNZyUjq7azKY0WnZ6zYI0wnBGTLCIYErS4l+XCRe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)