UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pwli3DiSl2V/a0MW1J5OqJlEAecWUsISCUpy1wGZURI='
WHERE
key_id = 'd0290714bb342c6bc3f53ee775042ffd1b8bec1b81fc1e698882bfde11b3195d'
AND (
token = 'Pwli3DiSl2V/a0MW1J5OqJlEAecWUsISCUpy1wGZURI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)