UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nz+4zGi/O4LluP/MQf97G1Es2U4yTb793cy8ybxGWh8='
WHERE
key_id = 'd1267453fb66923ef6c19f15f5983802be9b3a494b375f982b60ad4e59d00495'
AND (
token = 'Nz+4zGi/O4LluP/MQf97G1Es2U4yTb793cy8ybxGWh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)