UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q56ta0JuQWR/Nw8msluX1SBA5Ky6Q9gBnAUKyCy6CAA='
WHERE
key_id = 'b065cc59db2b5e226da804478abb4a154a0601e8b683eb64e812fae9dbd83a80'
AND (
token = 'q56ta0JuQWR/Nw8msluX1SBA5Ky6Q9gBnAUKyCy6CAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)