UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6vVRLhanRKmxzKvTW9mtQ8w8FwpUe4sLrNVMfStrw0='
WHERE
key_id = '3f9c9ddabe3b9ce23e2fca0628c3794011e2198010cc83cca1abe2668eaf9ceb'
AND (
token = 'C6vVRLhanRKmxzKvTW9mtQ8w8FwpUe4sLrNVMfStrw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)