UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bbXZpOBhv1mCinqD0y90PpHKLmoGECq9JYfxh7wi46E='
WHERE
key_id = '801e0f96927e34eccc31d2896da6925c461ce7b59984efa18da9ada1ae1bd916'
AND (
token = 'bbXZpOBhv1mCinqD0y90PpHKLmoGECq9JYfxh7wi46E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)