UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zlp/rG6ZDReBvC7FXq76zgJeb1fxd5bBes/KVQAaoUU='
WHERE
key_id = 'bcfac96d836d48b8c19b842486ead8b9b0e72b32f22a0a59d90d38675a7c8a3d'
AND (
token = 'Zlp/rG6ZDReBvC7FXq76zgJeb1fxd5bBes/KVQAaoUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)