UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C9gFwICp5qKslIxaQ+PJXoI4MPMzpdJnJrK9BITIQTE='
WHERE
key_id = '8cc124424f01081c17ff0ab4b7e0afa12fbd0b86207d0f98e29102a993614207'
AND (
token = 'C9gFwICp5qKslIxaQ+PJXoI4MPMzpdJnJrK9BITIQTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)