UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OBAvesuwMTsWSGCrCj9xBaGaEdfixSHAURWP/M6NDQA='
WHERE
key_id = 'e260874e0f13c46a6aa6ad80a9689eb27870edfd0c80ae564a06c917f1a6870e'
AND (
token = 'OBAvesuwMTsWSGCrCj9xBaGaEdfixSHAURWP/M6NDQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)