UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XLC1WE871Wn+Frdcp9qOUz2W3d1ar2vCi/Sa3jTh9cU='
WHERE
key_id = 'f3d071e95e43e895748cbf09334c9a562232193f7b9a946006faa2979229f4ae'
AND (
token = 'XLC1WE871Wn+Frdcp9qOUz2W3d1ar2vCi/Sa3jTh9cU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)