UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTfwScsKO6luzOd+1B9BPkwHTrkPvzX57MkAaeYdCmA='
WHERE
key_id = '594e1e5421c16a0640be244b9a89a2820a7bb2f390476dbf69701c7e0966f72e'
AND (
token = 'CTfwScsKO6luzOd+1B9BPkwHTrkPvzX57MkAaeYdCmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)