UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KCG113Uyzk0X+GZQINY2umkZPf92EWj8ttybJCC4+8s='
WHERE
key_id = '9c921cd594bb3799c88f78747d8982f9e07850e3b67e32068db964b24250f0b9'
AND (
token = 'KCG113Uyzk0X+GZQINY2umkZPf92EWj8ttybJCC4+8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)