UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v4yv7tYxqJR1rPkItcQ0WsL1KWP0BPkSLkIj5ACloME='
WHERE
key_id = 'd97ad5254d65d026ec00c99688e0b479b7f2b9bfcaed58807bb3373e8df2769b'
AND (
token = 'v4yv7tYxqJR1rPkItcQ0WsL1KWP0BPkSLkIj5ACloME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)