UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BpgARdrNQXhpEwYM2+LHe1DEYh+Wd04FhLR+RJ7HhL8='
WHERE
key_id = '1298f37298b1e4bfcf505eff63c7b2d225ae2e0db06aefe44f3823939b5be4fc'
AND (
token = 'BpgARdrNQXhpEwYM2+LHe1DEYh+Wd04FhLR+RJ7HhL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)