UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6dtOkMG97zApQiw1YED8n50+JJmoQqSH0gt1LR6mR4='
WHERE
key_id = 'f0c8627a406e135c36c5a734c3f7b7216aa4e2220ea14988a77dbc554b7c6c2b'
AND (
token = 'a6dtOkMG97zApQiw1YED8n50+JJmoQqSH0gt1LR6mR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)