UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qc5Gx5rPKSE5qz7hmQmSgOxL3dFP36Q825r/7jcBHNs='
WHERE
key_id = 'd8ab4df5e4eda9744a087e745aebbafca7fe16b75d12d9bc41bbbcb55b35fbb6'
AND (
token = 'qc5Gx5rPKSE5qz7hmQmSgOxL3dFP36Q825r/7jcBHNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)