UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2BE3mmwWcNhgGmvHKoKLpEx/Vp4MjQnnV4EgOoFxkas='
WHERE
key_id = 'aac9a04ffd96f072b48c9ca96c3f41cca43ac4ddf054f4a2090d4399f1988fb2'
AND (
token = '2BE3mmwWcNhgGmvHKoKLpEx/Vp4MjQnnV4EgOoFxkas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)