UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mJ56iHeIBq8e3Y+S40lr5dcUsqbIbvQUYZQMPvqGNq4='
WHERE
key_id = 'a1a9a315b8cc322cb5688b99c94e995a46755c621b441ee50d7f185385a5ca46'
AND (
token = 'mJ56iHeIBq8e3Y+S40lr5dcUsqbIbvQUYZQMPvqGNq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)