UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0LkogqsGuv8anUgykztOQuD6seQdDwGExJAV2yltff0='
WHERE
key_id = '4fa38d4cf74864600c346e126c775c774028b982a4648ae6f6c12ba5f3b039bc'
AND (
token = '0LkogqsGuv8anUgykztOQuD6seQdDwGExJAV2yltff0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)