UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lwXJLrQoodqbr9qHkLkL3gnaa62qlay5ghai46un10M='
WHERE
key_id = 'b33b7947e604fe4b0b652e5aa0edf070095d19f3848ac8ade635137e29285df7'
AND (
token = 'lwXJLrQoodqbr9qHkLkL3gnaa62qlay5ghai46un10M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)