UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQ3EtuG3YTRqvfxpOvwvXN4YchkS02CMxbcXn7RHfk4='
WHERE
key_id = '286a6c1017d1d99345af3de0ba6a0673b75a8e2ba8decda62211c08b08e533ef'
AND (
token = 'zQ3EtuG3YTRqvfxpOvwvXN4YchkS02CMxbcXn7RHfk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)