UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4KMQNrQwOBLnnN/c7UKiGN2wb7V1TBa87Xvy4O0C1z4='
WHERE
key_id = '2857831547cea29e918c770deb41d7f6c53a1398a08179f7998a8f07e000115a'
AND (
token = '4KMQNrQwOBLnnN/c7UKiGN2wb7V1TBa87Xvy4O0C1z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)