UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W3gqpHLN8zcOjhRWdsWcf+ygiLp9N6uuS5bhf8oZsWc='
WHERE
key_id = 'cb66dd4c73b16d26472cd0525781656ba0b2399dfd32b570ee8122c9971ced7a'
AND (
token = 'W3gqpHLN8zcOjhRWdsWcf+ygiLp9N6uuS5bhf8oZsWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)